# -*- coding: utf-8 -*-  
import pandas as pd

web_stats = {
    'Day': [1, 2, 3, 4, 5, 6],
    'Visitors': [43, 34, 65, 56, 29, 76],
    'Bounce Rate': [65, 67, 78, 65, 45, 52]
}

df1 = pd.DataFrame(web_stats)
df2 = pd.DataFrame(web_stats)
df2.rename(columns={'Day':'Day2'}, inplace=True)
df2.set_index('Day2', inplace=True)

df1.to_excel('pandas_to_excel1.xlsx', sheet_name='Sheet1')
df = pd.read_excel('pandas_to_excel1.xlsx', index_col=[0])
print(df)

with pd.ExcelWriter('pandas_to_excel.xlsx') as writer:
    df1.to_excel(writer, sheet_name='MulSheet1')
    df2.to_excel(writer, sheet_name='MulSheet2')

with pd.ExcelFile('pandas_to_excel.xlsx') as xls:
    dfr1 = pd.read_excel(xls, 'MulSheet1')
    dfr2 = pd.read_excel(xls, 'MulSheet2')
    print(dfr1)
    print(dfr2)